TransactionAssociation

Entity Definition

Logical Name : TransactionAssociation
Physical Name : ST_ASCTN_TRN

Associative entity recording relationships between two Transactions.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
RefersToTransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN_TO IdentityUUID char(32) Transaction(TR_TRN)
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32) Transaction(TR_TRN)
TransactionAssociationTypeCode (FK)(PK) A retailer assigned code denoting the kind of relationship between the two Transactions. CD_TYP_TRN_ASCTN Code4 char(4) TransactionAssociationType(CO_TRN_ASCTN)
SequenceNumber (PK) A number that indicates the presentation order of TransactionAssociation entity type instances. The use of this attribute is determined by the application logic used to create and use this association. It may be used to indicate chronological order OR it may be used to establish a precedence in how retail transaction associations are to be processed. IC_ASCTN_LTM_RTL_SQN_NMB LineNumber smallint
ReasonCode (FK) A unique retailer defined reason code for an action that is taken (or not taken) at a Workstation. e.g. Return reason codes - Past Use By Date, Defective Merchandise, etc. POSNoSale reason Codes - Customer Change Query CD_RSN Code varchar(20) Reason(CO_CD_RSN)
TransactionAssociationEntryMethodCode A code to denote how the TransactionAssociation was entered at the Workstation. CD_TRN_ASCTN_ENR_MTH EntryMethodCode varchar(20)
OriginalSourceTransactionAssociationFlag A boolean indicator that if set to YES or TRUE means that this association instance is the first of multiple associations. Note that this applies primarily where SequenceNumber is used as a precedence determination value NOT a chronological value. This requires some additional discussion and clarification. FL_ORGL_SRC_TRN_ASCTN Flag integer

Relationships

Parent Entity Verb Phrase Child Entity
Transaction refers to TransactionAssociation
TransactionAssociationType defines TransactionAssociation
Reason classifies TransactionAssociation
Transaction is referred to TransactionAssociation

Logical Views containing TransactionAssociation

Logical View
Logical 02200 - Transaction Macro View
Logical 02300 - Retail Transaction - Macro View
Logical 02305 - Retail Transaction - Header View